package com.gmrz.uap.common;
public class DBCommon {
public static final String TABLE_AUTH_METADATA = "t_auth_metadata";
public static final String TABLE_AUTH_METADATA_COLUMN_METADATA_ID = "metadata_id";
public static final String TABLE_AUTH_METADATA_COLUMN_AAID = "aaid";
public static final String TABLE_AUTH_METADATA_COLUMN_AUTH_VERSION = "auth_version";
public static final String TABLE_AUTH_METADATA_COLUMN_DESCRIPTION = "description";
public static final String TABLE_AUTH_METADATA_COLUMN_JSON_DATA = "json_data";
public static final String TABLE_AUTH_METADATA_COLUMN_STATUS = "status";
public static final String TABLE_AUTH_METADATA_COLUMN_CREATETS = "createts";
public static final String TABLE_AUTH_METADATA_COLUMN_UPDATETS = "updatets";
public static final String TABLE_AUTH_METADATA_COLUMN_AUTH_TYPE = "auth_type";
public static final String TABLE_AUTH_METADATA_COLUMN_PROTOCOL = "protocol";





public static final String TABLE_AUTHENTICATORS = "t_authenticators";
public static final String TABLE_AUTHENTICATORS_COLUMN_AUTH_ID = "auth_id";
public static final String TABLE_AUTHENTICATORS_COLUMN_METADATA_ID = "metadata_id";
public static final String TABLE_AUTHENTICATORS_COLUMN_USER_NAME = "user_name";
public static final String TABLE_AUTHENTICATORS_COLUMN_CUST_NO = "cust_no";
public static final String TABLE_AUTHENTICATORS_COLUMN_AAID = "aaid";
public static final String TABLE_AUTHENTICATORS_COLUMN_KEYID = "keyid";
public static final String TABLE_AUTHENTICATORS_COLUMN_PUBKEY = "pubkey";
public static final String TABLE_AUTHENTICATORS_COLUMN_KEY_FORMAT = "key_format";
public static final String TABLE_AUTHENTICATORS_COLUMN_SIGN_COUNTER = "sign_counter";
public static final String TABLE_AUTHENTICATORS_COLUMN_REG_COUNTER = "reg_counter";
public static final String TABLE_AUTHENTICATORS_COLUMN_DEVICE_ID = "device_id";
public static final String TABLE_AUTHENTICATORS_COLUMN_STATUS = "status";
public static final String TABLE_AUTHENTICATORS_COLUMN_PNG_CHAR = "png_char";
public static final String TABLE_AUTHENTICATORS_COLUMN_CREATETS = "createts";
public static final String TABLE_AUTHENTICATORS_COLUMN_UPDATETS = "updatets";
public static final String TABLE_AUTHENTICATORS_COLUMN_TENANT_ID = "tenant_id";
public static final String TABLE_AUTHENTICATORS_COLUMN_TRANS_TYPE = "trans_type";
public static final String TABLE_AUTHENTICATORS_COLUMN_AUTH_TYPE = "auth_type";
public static final String TABLE_AUTHENTICATORS_COLUMN_UVI = "uvi";
public static final String TABLE_AUTHENTICATORS_COLUMN_UVS = "uvs";
public static final String TABLE_AUTHENTICATORS_COLUMN_MOBILE = "mobile";
public static final String TABLE_AUTHENTICATORS_COLUMN_CUST_TYPE = "cust_type";
public static final String TABLE_AUTHENTICATORS_COLUMN_INST_CODE = "inst_code";
public static final String TABLE_AUTHENTICATORS_COLUMN_RF1 = "rf1";
public static final String TABLE_AUTHENTICATORS_COLUMN_RF2 = "rf2";
public static final String TABLE_AUTHENTICATORS_COLUMN_REG_FROM = "reg_from";





public static final String TABLE_CERTIFICATE = "t_certificate";
public static final String TABLE_CERTIFICATE_COLUMN_CRT_ID = "crt_id";
public static final String TABLE_CERTIFICATE_COLUMN_AUTH_ID = "auth_id";
public static final String TABLE_CERTIFICATE_COLUMN_KEYID = "keyid";
public static final String TABLE_CERTIFICATE_COLUMN_CERT_ID = "cert_id";
public static final String TABLE_CERTIFICATE_COLUMN_CERT_TEXT = "cert_text";
public static final String TABLE_CERTIFICATE_COLUMN_CERT_NO = "cert_no";
public static final String TABLE_CERTIFICATE_COLUMN_TENANT_ID = "tenant_id";
public static final String TABLE_CERTIFICATE_COLUMN_DEVICE_ID = "device_id";
public static final String TABLE_CERTIFICATE_COLUMN_AUTH_TYPE = "auth_type";
public static final String TABLE_CERTIFICATE_COLUMN_TRANS_TYPE = "trans_type";
public static final String TABLE_CERTIFICATE_COLUMN_AAID = "aaid";
public static final String TABLE_CERTIFICATE_COLUMN_IS_REPEAT = "is_repeat";
public static final String TABLE_CERTIFICATE_COLUMN_DATA1 = "data1";
public static final String TABLE_CERTIFICATE_COLUMN_DATA2 = "data2";





public static final String TABLE_DATA_STATISTICS = "t_data_statistics";
public static final String TABLE_DATA_STATISTICS_COLUMN_DSTC_ID = "dstc_id";
public static final String TABLE_DATA_STATISTICS_COLUMN_TENANT_ID = "tenant_id";
public static final String TABLE_DATA_STATISTICS_COLUMN_STA_TYPE = "sta_type";
public static final String TABLE_DATA_STATISTICS_COLUMN_STA_DATE = "sta_date";
public static final String TABLE_DATA_STATISTICS_COLUMN_STA_DATEOver = "data1";
public static final String TABLE_DATA_STATISTICS_COLUMN_STA_COUNT = "sta_count";
public static final String TABLE_DATA_STATISTICS_COLUMN_AUTH_TYPE = "auth_type";
public static final String TABLE_DATA_STATISTICS_COLUMN_TRANS_TYPE = "trans_type";
public static final String TABLE_DATA_STATISTICS_COLUMN_AAID = "aaid";
public static final String TABLE_DATA_STATISTICS_COLUMN_OPER_TYPE = "oper_type";
public static final String TABLE_DATA_STATISTICS_COLUMN_OS_TYPE = "os_type";
public static final String TABLE_DATA_STATISTICS_COLUMN_OS_VERSION = "os_version";
public static final String TABLE_DATA_STATISTICS_COLUMN_DEVICE_TYPE = "device_type";
public static final String TABLE_DATA_STATISTICS_COLUMN_DEVICE_NAME = "device_name";
public static final String TABLE_DATA_STATISTICS_COLUMN_CREATETS = "createts";
public static final String TABLE_DATA_STATISTICS_COLUMN_UPDATETS = "updatets";
public static final String TABLE_DATA_STATISTICS_COLUMN_DATA1 = "data1";
public static final String TABLE_DATA_STATISTICS_COLUMN_DATA2 = "data2";
public static final String TABLE_DATA_STATISTICS_COLUMN_INSTCODE = "inst_code";





public static final String TABLE_DEVICE_ALIAS = "t_device_alias";
public static final String TABLE_DEVICE_ALIAS_COLUMN_DEVICE_ALIAS_ID = "device_alias_id";
public static final String TABLE_DEVICE_ALIAS_COLUMN_DEVICE_TYPE = "device_type";
public static final String TABLE_DEVICE_ALIAS_COLUMN_DEVICE_NAME = "device_name";
public static final String TABLE_DEVICE_ALIAS_COLUMN_DEVICE_TYPE_ALIAS = "device_type_alias";
public static final String TABLE_DEVICE_ALIAS_COLUMN_DEVICE_NAME_ALIAS = "device_name_alias";





public static final String TABLE_DEVICE_FORBID = "t_device_forbid";
public static final String TABLE_DEVICE_FORBID_COLUMN_DF_ID = "df_id";
public static final String TABLE_DEVICE_FORBID_COLUMN_DEVICE_ID = "device_id";
public static final String TABLE_DEVICE_FORBID_COLUMN_DES = "des";
public static final String TABLE_DEVICE_FORBID_COLUMN_TENANT_ID = "tenant_id";





public static final String TABLE_DEVICES = "t_devices";
public static final String TABLE_DEVICES_COLUMN_DEV_ID = "dev_id";
public static final String TABLE_DEVICES_COLUMN_USER_NAME = "user_name";
public static final String TABLE_DEVICES_COLUMN_ALIAS_NAME = "alias_name";
public static final String TABLE_DEVICES_COLUMN_TRANS_TYPE = "trans_type";
public static final String TABLE_DEVICES_COLUMN_AUTH_TYPE = "auth_type";
public static final String TABLE_DEVICES_COLUMN_DEVICE_ID = "device_id";
public static final String TABLE_DEVICES_COLUMN_REQUEST = "request";
public static final String TABLE_DEVICES_COLUMN_DEVICE_TYPE = "device_type";
public static final String TABLE_DEVICES_COLUMN_DEVICE_NAME = "device_name";
public static final String TABLE_DEVICES_COLUMN_OS_VERSION = "os_version";
public static final String TABLE_DEVICES_COLUMN_OS_TYPE = "os_type";
public static final String TABLE_DEVICES_COLUMN_IMEI = "imei";
public static final String TABLE_DEVICES_COLUMN_MAC = "mac";
public static final String TABLE_DEVICES_COLUMN_STATUS = "status";
public static final String TABLE_DEVICES_COLUMN_CREATETS = "createts";
public static final String TABLE_DEVICES_COLUMN_UPDATETS = "updatets";
public static final String TABLE_DEVICES_COLUMN_TENANT_ID = "tenant_id";





public static final String TABLE_DICT = "t_dict";
public static final String TABLE_DICT_COLUMN_DICT_ID = "dict_id";
public static final String TABLE_DICT_COLUMN_DT_ID = "dt_id";
public static final String TABLE_DICT_COLUMN_DICT_NAME = "dict_name";
public static final String TABLE_DICT_COLUMN_DICT_TEXT = "dict_text";
public static final String TABLE_DICT_COLUMN_IS_ENABLE = "is_enable";
public static final String TABLE_DICT_COLUMN_ORDER_NUMBER = "order_number";
public static final String TABLE_DICT_COLUMN_DATA1 = "data1";
public static final String TABLE_DICT_COLUMN_DATA2 = "data2";
public static final String TABLE_DICT_COLUMN_DES = "des";





public static final String TABLE_DICT_TYPE = "t_dict_type";
public static final String TABLE_DICT_TYPE_COLUMN_DT_ID = "dt_id";
public static final String TABLE_DICT_TYPE_COLUMN_DT_NAME = "dt_name";
public static final String TABLE_DICT_TYPE_COLUMN_ORDER_NUMBER = "order_number";
public static final String TABLE_DICT_TYPE_COLUMN_IS_ENABLE = "is_enable";





public static final String TABLE_EQUIPMENT = "t_equipment";
public static final String TABLE_EQUIPMENT_COLUMN_EQU_ID = "equ_id";
public static final String TABLE_EQUIPMENT_COLUMN_VEN_ID = "ven_id";
public static final String TABLE_EQUIPMENT_COLUMN_EQU_MODEL = "equ_model";
public static final String TABLE_EQUIPMENT_COLUMN_STATUS = "status";
public static final String TABLE_EQUIPMENT_COLUMN_CREATETS = "createts";





public static final String TABLE_EQUIPMENT_AUTH = "t_equipment_auth";
public static final String TABLE_EQUIPMENT_AUTH_COLUMN_METADATA_ID = "metadata_id";
public static final String TABLE_EQUIPMENT_AUTH_COLUMN_EQU_ID = "equ_id";





public static final String TABLE_EQUIPMENT_FORBID = "t_equipment_forbid";
public static final String TABLE_EQUIPMENT_FORBID_COLUMN_EA_ID = "ea_id";
public static final String TABLE_EQUIPMENT_FORBID_COLUMN_EQU_ID = "equ_id";
public static final String TABLE_EQUIPMENT_FORBID_COLUMN_VEN_ID = "ven_id";
public static final String TABLE_EQUIPMENT_FORBID_COLUMN_TENANT_ID = "tenant_id";





public static final String TABLE_EQUIPMENT_VERSION = "t_equipment_version";
public static final String TABLE_EQUIPMENT_VERSION_COLUMN_EQU_VERSION_ID = "equ_version_id";
public static final String TABLE_EQUIPMENT_VERSION_COLUMN_EQU_ID = "equ_id";
public static final String TABLE_EQUIPMENT_VERSION_COLUMN_EQU_VERSION = "equ_version";
public static final String TABLE_EQUIPMENT_VERSION_COLUMN_STATUS = "status";
public static final String TABLE_EQUIPMENT_VERSION_COLUMN_CREATETS = "createts";





public static final String TABLE_FACEPRINT_DATA = "t_faceprint_data";
public static final String TABLE_FACEPRINT_DATA_COLUMN_USERNAME = "username";
public static final String TABLE_FACEPRINT_DATA_COLUMN_FACE_DATA = "face_data";





public static final String TABLE_FACETS = "t_facets";
public static final String TABLE_FACETS_COLUMN_FACET_ID = "facet_id";
public static final String TABLE_FACETS_COLUMN_FACET_NAME = "facet_name";
public static final String TABLE_FACETS_COLUMN_FACET_TYPE = "facet_type";
public static final String TABLE_FACETS_COLUMN_AUTH_CODE = "auth_code";
public static final String TABLE_FACETS_COLUMN_CREATETS = "createts";
public static final String TABLE_FACETS_COLUMN_UPDATETS = "updatets";
public static final String TABLE_FACETS_COLUMN_TENANT_ID = "tenant_id";





public static final String TABLE_PLUGIN_ARGUMENT = "t_plugin_argument";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_PA_ID = "pa_id";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_SP_ID = "sp_id";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_CONFIG_CNAME = "config_cname";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_CONFIG_VALUE = "config_value";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_DES = "des";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_CREATETS = "createts";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_UPDATETS = "updatets";
public static final String TABLE_PLUGIN_ARGUMENT_COLUMN_ORDER_NUMBER = "order_number";





public static final String TABLE_POLICY = "t_policy";
public static final String TABLE_POLICY_COLUMN_PL_ID = "pl_id";
public static final String TABLE_POLICY_COLUMN_POLICY_NAME = "policy_name";
public static final String TABLE_POLICY_COLUMN_AUTH_TYPE = "auth_type";
public static final String TABLE_POLICY_COLUMN_TRANS_TYPE = "trans_type";
public static final String TABLE_POLICY_COLUMN_TENANT_ID = "tenant_id";
public static final String TABLE_POLICY_COLUMN_CREATETS = "createts";





public static final String TABLE_POLICY_AUTH = "t_policy_auth";
public static final String TABLE_POLICY_AUTH_COLUMN_PL_ID = "pl_id";
public static final String TABLE_POLICY_AUTH_COLUMN_METADATA_ID = "metadata_id";





public static final String TABLE_RESOURCE = "t_resource";
public static final String TABLE_RESOURCE_COLUMN_RESOURCE_ID = "resource_id";
public static final String TABLE_RESOURCE_COLUMN_RESOURCE_NAME = "resource_name";
public static final String TABLE_RESOURCE_COLUMN_PID = "pid";
public static final String TABLE_RESOURCE_COLUMN_URL = "url";
public static final String TABLE_RESOURCE_COLUMN_RESOURCE_TYPE = "resource_type";
public static final String TABLE_RESOURCE_COLUMN_ICON = "icon";
public static final String TABLE_RESOURCE_COLUMN_DES = "des";
public static final String TABLE_RESOURCE_COLUMN_IS_ENABLE = "is_enable";
public static final String TABLE_RESOURCE_COLUMN_ORDER_NUMBER = "order_number";
public static final String TABLE_RESOURCE_COLUMN_CREATETS = "createts";
public static final String TABLE_RESOURCE_COLUMN_UPDATETS = "updatets";





public static final String TABLE_RESOURCE_ROLE = "t_resource_role";
public static final String TABLE_RESOURCE_ROLE_COLUMN_USER_ID = "user_id";
public static final String TABLE_RESOURCE_ROLE_COLUMN_ROLE_ID = "role_id";
public static final String TABLE_RESOURCE_ROLE_COLUMN_RESOURCE_ID = "resource_id";
public static final String TABLE_RESOURCE_ROLE_COLUMN_CHECK_STATE = "check_state";





public static final String TABLE_ROLE = "t_role";
public static final String TABLE_ROLE_COLUMN_ROLE_ID = "role_id";
public static final String TABLE_ROLE_COLUMN_ROLE_NAME = "role_name";
public static final String TABLE_ROLE_COLUMN_ICON = "icon";
public static final String TABLE_ROLE_COLUMN_PID = "pid";
public static final String TABLE_ROLE_COLUMN_DES = "des";
public static final String TABLE_ROLE_COLUMN_ORDER_NUMBER = "order_number";
public static final String TABLE_ROLE_COLUMN_CREATETS = "createts";
public static final String TABLE_ROLE_COLUMN_UPDATETS = "updatets";





public static final String TABLE_SERVICE_PLUGIN = "t_service_plugin";
public static final String TABLE_SERVICE_PLUGIN_COLUMN_SP_ID = "sp_id";
public static final String TABLE_SERVICE_PLUGIN_COLUMN_PLUGIN_NAME = "plugin_name";
public static final String TABLE_SERVICE_PLUGIN_COLUMN_CLASS_NAME = "class_name";
public static final String TABLE_SERVICE_PLUGIN_COLUMN_DES = "des";
public static final String TABLE_SERVICE_PLUGIN_COLUMN_AAID = "aaid";





public static final String TABLE_TENANT = "t_tenant";
public static final String TABLE_TENANT_COLUMN_TAN_ID = "tan_id";
public static final String TABLE_TENANT_COLUMN_TENANT_ID = "tenant_id";
public static final String TABLE_TENANT_COLUMN_ALIAS_NAME = "alias_name";
public static final String TABLE_TENANT_COLUMN_STATUS = "status";
public static final String TABLE_TENANT_COLUMN_CREATETS = "createts";
public static final String TABLE_TENANT_COLUMN_UPDATETS = "updatets";





public static final String TABLE_TENANT_CONFIG = "t_tenant_config";
public static final String TABLE_TENANT_CONFIG_COLUMN_TC_ID = "tc_id";
public static final String TABLE_TENANT_CONFIG_COLUMN_CONFIG_CNAME = "config_cname";
public static final String TABLE_TENANT_CONFIG_COLUMN_CONFIG_ENAME = "config_ename";
public static final String TABLE_TENANT_CONFIG_COLUMN_CONFIG_VALUE = "config_value";
public static final String TABLE_TENANT_CONFIG_COLUMN_DATA_TYPE = "data_type";
public static final String TABLE_TENANT_CONFIG_COLUMN_REGEX = "regex";
public static final String TABLE_TENANT_CONFIG_COLUMN_ERROR_MSG = "error_msg";
public static final String TABLE_TENANT_CONFIG_COLUMN_CREATETS = "createts";
public static final String TABLE_TENANT_CONFIG_COLUMN_TENANT_ID = "tenant_id";
public static final String TABLE_TENANT_CONFIG_COLUMN_TRANS_TYPE = "trans_type";





public static final String TABLE_UAS_CONFIG = "t_uas_config";
public static final String TABLE_UAS_CONFIG_COLUMN_CONFIG_ID = "config_id";
public static final String TABLE_UAS_CONFIG_COLUMN_CONFIG_CNAME = "config_cname";
public static final String TABLE_UAS_CONFIG_COLUMN_CONFIG_ENAME = "config_ename";
public static final String TABLE_UAS_CONFIG_COLUMN_CONFIG_VALUE = "config_value";
public static final String TABLE_UAS_CONFIG_COLUMN_CONFIG_TYPE = "config_type";
public static final String TABLE_UAS_CONFIG_COLUMN_CONFIG_USER_DEFINED = "config_user_defined";
public static final String TABLE_UAS_CONFIG_COLUMN_CONFIG_DEFAULT_VALUE = "config_default_value";
public static final String TABLE_UAS_CONFIG_COLUMN_CREATETS = "createts";
public static final String TABLE_UAS_CONFIG_COLUMN_UPDATETS = "updatets";
public static final String TABLE_UAS_CONFIG_COLUMN_ORDER_NUMBER = "order_number";
public static final String TABLE_UAS_CONFIG_COLUMN_DATA_TYPE = "data_type";
public static final String TABLE_UAS_CONFIG_COLUMN_REGEX = "regex";
public static final String TABLE_UAS_CONFIG_COLUMN_ERROR_MSG = "error_msg";





public static final String TABLE_USER = "t_user";
public static final String TABLE_USER_COLUMN_USER_ID = "user_id";
public static final String TABLE_USER_COLUMN_USER_NAME = "user_name";
public static final String TABLE_USER_COLUMN_PWD = "pwd";
public static final String TABLE_USER_COLUMN_ICON = "icon";
public static final String TABLE_USER_COLUMN_EMAIL = "email";
public static final String TABLE_USER_COLUMN_PHONE = "phone";
public static final String TABLE_USER_COLUMN_DES = "des";
public static final String TABLE_USER_COLUMN_CREATETS = "createts";
public static final String TABLE_USER_COLUMN_UPDATETS = "updatets";
public static final String TABLE_USER_COLUMN_TENANT_ID = "tenant_id";





public static final String TABLE_USER_ROLE = "t_user_role";
public static final String TABLE_USER_ROLE_COLUMN_USER_ID = "user_id";
public static final String TABLE_USER_ROLE_COLUMN_ROLE_ID = "role_id";





public static final String TABLE_VENDOR = "t_vendor";
public static final String TABLE_VENDOR_COLUMN_VEN_ID = "ven_id";
public static final String TABLE_VENDOR_COLUMN_VENDOR_NAME = "vendor_name";
public static final String TABLE_VENDOR_COLUMN_VENDOR_ALIAS = "vendor_alias";





public static final String TABLE_VENDOR_ALLOW = "t_vendor_allow";
public static final String TABLE_VENDOR_ALLOW_COLUMN_VF_ID = "vf_id";
public static final String TABLE_VENDOR_ALLOW_COLUMN_VEN_ID = "ven_id";
public static final String TABLE_VENDOR_ALLOW_COLUMN_TENANT_ID = "tenant_id";





public static final String TABLE_WEBAUTHN_AUTHENTICATORS = "t_webauthn_authenticators";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_AUTH_ID = "auth_id";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_USERID = "userid";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_DISPLAY_NAME = "display_name";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_ATTESTATION_FORMAT = "attestation_format";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_TRANSPORT = "transport";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_TYPE = "type";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_CREDENTIAL_ID = "credential_id";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_SIGN_ALGO = "sign_algo";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_AUTH_COUNTER = "auth_counter";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_CERT_CHAIN_HASH = "cert_chain_hash";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_CREATETS = "createts";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_UPDATETS = "updatets";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_RF1 = "rf1";
public static final String TABLE_WEBAUTHN_AUTHENTICATORS_COLUMN_RF2 = "rf2";





public static final String TABLE_WHITE_LIST = "t_white_list";
public static final String TABLE_WHITE_LIST_COLUMN_WL_ID = "wl_id";
public static final String TABLE_WHITE_LIST_COLUMN_VISIT_ADDRESS = "visit_address";
public static final String TABLE_WHITE_LIST_COLUMN_TENANT_ID = "tenant_id";





}